--------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/mattfuhrmann/Dropbox/Alliances(BerkemeierFuhrmann2016)/RAP R
> eview/For submission/Log File.log
  log type:  text
 opened on:   6 Mar 2018, 22:11:56

. do "/var/folders/v8/1k3hmff90bs55w36h78zbg440000gn/T//SD00418.000000"

. /* 
> Replication files for:                                                        
>                                                           
> Title: ``Reassessing the Fulfillment of Alliance Commitments in War''
> Journal: Research and Politics  
> Authors: Molly Berkemeier and Matthew Fuhrmann          
> Date: 5 March 2018              
> */
. 
. *Open the dataset
. use "BerkemeierFuhrmannRAP2018_0303.dta", clear

. 
. ******************************************************************************
> **
. *Figure 1
. ******************************************************************************
> **
. 
. *Identify total number of relevant alliance performance opportunities
. tab dnaLLM //430 of 576 cases are ``DNA.'' 146 observations (576-430) are rele
> vant.

     dnaLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        430      100.00      100.00
------------+-----------------------------------
      Total |        430      100.00

. 
. *Identify number of alliance performance opportunities that are fulfilled
. tab honorLLM // 73 commitments fulfilled

   honorLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         73      100.00      100.00
------------+-----------------------------------
      Total |         73      100.00

. 
. *Calculate compliance rate
. disp 73/146
.5

. tab violateLLM // 50%

 violateLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         73      100.00      100.00
------------+-----------------------------------
      Total |         73      100.00

. 
. ******************************************************************************
> **
. *Figure 2
. ******************************************************************************
> **
. 
. *1816-1944
. 
. *Identify total number of relevant alliance performance opportunities
. tab sample // 204 total observations.

     sample |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |        372       64.58       64.58
          1 |        204       35.42      100.00
------------+-----------------------------------
      Total |        576      100.00

. tab dnaLLM if sample==1 // 112 ``DNA.'' 92 observations (204-112) are relevant
> .

     dnaLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        112      100.00      100.00
------------+-----------------------------------
      Total |        112      100.00

. 
. *Identify number of alliance performance opportunities that are fulfilled
. tab honorLLM if sample==1 // 61 commitments fulfilled

   honorLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         61      100.00      100.00
------------+-----------------------------------
      Total |         61      100.00

. 
. *Calculate compliance rate
. disp 61/92 // 66.30%
.66304348

. 
. *1945-2003
. 
. *Identify total number of relevant alliance performance opportunities
. tab sample // 372 total observations.

     sample |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |        372       64.58       64.58
          1 |        204       35.42      100.00
------------+-----------------------------------
      Total |        576      100.00

. tab dnaLLM if sample==0 // 318 ``DNA.'' 54 observations (372-318) are relevant
> .

     dnaLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        318      100.00      100.00
------------+-----------------------------------
      Total |        318      100.00

. 
. *Identify number of alliance performance opportunities that are fulfilled
. tab honorLLM if sample==0 // 12 commitments fulfilled

   honorLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         12      100.00      100.00
------------+-----------------------------------
      Total |         12      100.00

. 
. *Calculate compliance rate
. disp 12/54 // 22.22%
.22222222

. 
. ******************************************************************************
> **
. *Table 1
. ******************************************************************************
> **
. 
. list warid warname atopid honorLLM if sample==0 & dnaLLM~=1

     +------------------------------------------------------+
     | warid                    warname   atopid   honorLLM |
     |------------------------------------------------------|
126. |    56             Korean_1950-53     2170          1 |
127. |    59       Soviet-Hungarian1956     2170          1 |
222. |    53                 WorldWarII     3005          1 |
223. |    53                 WorldWarII     3010          . |
224. |    82                GulfWar1991     3015          . |
     |------------------------------------------------------|
237. |    53                 WorldWarII     3020          . |
240. |    53                 WorldWarII     3030          1 |
248. |    67              Football_1969     3075          . |
258. |    59       Soviet-Hungarian1956     3110          . |
262. |    59       Soviet-Hungarian1956     3120          . |
     |------------------------------------------------------|
283. |    67              Football_1969     3150          . |
313. |    79                Lebanon1982     3205          . |
315. |    82                GulfWar1991     3205          . |
318. |    88                   Iraq2003     3205          . |
319. |    58                  Sinai1956     3205          . |
     |------------------------------------------------------|
320. |    80         AouzouStrip1986-87     3205          . |
321. |    73      SecondOgaden1977-1978     3205          . |
322. |    64                SixDay_1967     3205          . |
324. |    56             Korean_1950-53     3210          1 |
334. |    56             Korean_1950-53     3215          . |
     |------------------------------------------------------|
352. |    69             Bangladesh1971     3260          . |
359. |    60         TaiwanStraits_1958     3270          . |
361. |    57    OffShoreIslands_1954-55     3270          . |
368. |    59       Soviet-Hungarian1956     3285          . |
377. |    58                  Sinai1956     3300          . |
     |------------------------------------------------------|
378. |    58                  Sinai1956     3305          . |
379. |    58                  Sinai1956     3310          . |
383. |    58                  Sinai1956     3322          1 |
385. |    94         Malaysia_1963-1966     3330          1 |
388. |    64                SixDay_1967     3350          . |
     |------------------------------------------------------|
393. |    69             Bangladesh1971     3355          . |
417. |    93                Bizerte1961     3390          . |
418. |    93                Bizerte1961     3395          . |
423. |    93                Bizerte1961     3410          . |
447. |    70              YomKippur1973     3465          1 |
     |------------------------------------------------------|
448. |    64                SixDay_1967     3465          . |
449. |    64                SixDay_1967     3467          . |
455. |    73      SecondOgaden1977-1978     3485          . |
456. |    84            Badme_1998-2001     3485          . |
457. |    67              Football_1969     3490          . |
     |------------------------------------------------------|
470. |    69             Bangladesh1971     3530          . |
471. |    64                SixDay_1967     3538          1 |
473. |    64                SixDay_1967     3570          . |
477. |    69             Bangladesh1971     3675          1 |
481. |    75   Ugandan-Tanzanian1978-79     3700          . |
     |------------------------------------------------------|
482. |    86                 Kargil1999     3705          . |
491. |    83     Azeri-Armenian_1993-94     3740          . |
500. |    79                Lebanon1982     3807          . |
526. |    82                GulfWar1991     3997          . |
530. |    82                GulfWar1991     4020          1 |
     |------------------------------------------------------|
548. |    83     Azeri-Armenian_1993-94     4220          . |
555. |    83     Azeri-Armenian_1993-94     4400          . |
568. |    83     Azeri-Armenian_1993-94     4550          . |
575. |    85                 Kosovo1999     4820          1 |
     +------------------------------------------------------+

. list atopid defense offense neutral nonagg if sample==0 & dnaLLM~=1

     +-----------------------------------------------+
     | atopid   defense   offense   neutral   nonagg |
     |-----------------------------------------------|
126. |   2170         0         0         1        1 |
127. |   2170         0         0         1        1 |
222. |   3005         0         1         0        0 |
223. |   3010         1         0         0        0 |
224. |   3015         0         0         0        1 |
     |-----------------------------------------------|
237. |   3020         1         1         0        0 |
240. |   3030         1         1         0        0 |
248. |   3075         1         0         0        1 |
258. |   3110         1         0         0        1 |
262. |   3120         1         1         0        1 |
     |-----------------------------------------------|
283. |   3150         1         0         0        1 |
313. |   3205         1         0         0        1 |
315. |   3205         1         0         0        1 |
318. |   3205         1         0         0        1 |
319. |   3205         1         0         0        1 |
     |-----------------------------------------------|
320. |   3205         1         0         0        1 |
321. |   3205         1         0         0        1 |
322. |   3205         1         0         0        1 |
324. |   3210         1         0         0        1 |
334. |   3215         1         0         0        1 |
     |-----------------------------------------------|
352. |   3260         1         0         0        1 |
359. |   3270         1         0         0        1 |
361. |   3270         1         0         0        1 |
368. |   3285         1         0         0        1 |
377. |   3300         1         0         0        0 |
     |-----------------------------------------------|
378. |   3305         1         0         0        0 |
379. |   3310         1         0         0        0 |
383. |   3322         0         1         1        0 |
385. |   3330         1         0         0        0 |
388. |   3350         1         0         0        0 |
     |-----------------------------------------------|
393. |   3355         1         0         0        0 |
417. |   3390         1         0         0        0 |
418. |   3395         1         0         0        0 |
423. |   3410         1         0         0        0 |
447. |   3465         1         1         0        0 |
     |-----------------------------------------------|
448. |   3465         1         1         0        0 |
449. |   3467         1         0         0        0 |
455. |   3485         1         0         0        0 |
456. |   3485         1         0         0        0 |
457. |   3490         1         0         0        0 |
     |-----------------------------------------------|
470. |   3530         0         0         0        1 |
471. |   3538         1         0         0        0 |
473. |   3570         1         0         0        0 |
477. |   3675         0         0         1        1 |
481. |   3700         1         0         0        0 |
     |-----------------------------------------------|
482. |   3705         0         0         0        1 |
491. |   3740         0         0         0        1 |
500. |   3807         1         0         0        0 |
526. |   3997         0         0         0        1 |
530. |   4020         1         0         0        0 |
     |-----------------------------------------------|
548. |   4220         1         0         0        1 |
555. |   4400         1         0         0        1 |
568. |   4550         1         0         0        0 |
575. |   4820         0         0         1        1 |
     +-----------------------------------------------+

. 
. ******************************************************************************
> **
. *Other figures mentioned in the paper
. ******************************************************************************
> **
. 
. *Identify compliance rates by commitment type
. 
. tab honorLLM if defense==1 // 42/102=41.18%

   honorLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         42      100.00      100.00
------------+-----------------------------------
      Total |         42      100.00

.         *Total defense pact observations: 301
.         *Defense pacts DNA: 199
.         *Total defense alliance performance opportunities: 102 (301-199)
. 
. tab honorLLM if offense==1 // 31/42=73.81%

   honorLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         31      100.00      100.00
------------+-----------------------------------
      Total |         31      100.00

.         *Total offense pact observations: 73
.         *Offense pacts DNA: 31
.         *Total offense pact alliance performance opportunities: 42 (73-31)
. 
. tab honorLLM if neutral==1 // 35/45=77.78%

   honorLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         35      100.00      100.00
------------+-----------------------------------
      Total |         35      100.00

.         *Total neutrality pact observations: 80
.         *Neutrality pact DNA: 35
.         *Total neutrality alliance performance opportunities: 45 (80-35)
. 
. tab honorLLM if nonagg==1 // 18/49=36.73%

   honorLLM |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         18      100.00      100.00
------------+-----------------------------------
      Total |         18      100.00

.         *Total nonaggression pact observations: 263
.         *Nonaggression pact DNA: 214
.         *Total nonaggression alliance performance opportunities: 49 (263-214)
. 
. *Identify the number of neutrality and offense pacts pre- and post-1945
. g neu_offense=0

. replace neu_offense=1 if neutral==1
(80 real changes made)

. replace neu_offense=1 if offense==1
(59 real changes made)

. tab neu_offense sample if dnaLLM~=1, column

+-------------------+
| Key               |
|-------------------|
|     frequency     |
| column percentage |
+-------------------+

neu_offens |        sample
         e |         0          1 |     Total
-----------+----------------------+----------
         0 |        43         26 |        69 
           |     79.63      28.26 |     47.26 
-----------+----------------------+----------
         1 |        11         66 |        77 
           |     20.37      71.74 |     52.74 
-----------+----------------------+----------
     Total |        54         92 |       146 
           |    100.00     100.00 |    100.00 


. 
. *Identify defense pact compliance pre- and post-1945
. tab defense if dnaLLM~=1 & sample==1

      (max) |
    defense |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |         33       35.87       35.87
          1 |         59       64.13      100.00
------------+-----------------------------------
      Total |         92      100.00

. tab defense if dnaLLM~=1 & sample==0

      (max) |
    defense |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |         11       20.37       20.37
          1 |         43       79.63      100.00
------------+-----------------------------------
      Total |         54      100.00

. tab honorLLM defense if dnaLLM~=1 & sample==1, column //36/59=61.02

+-------------------+
| Key               |
|-------------------|
|     frequency     |
| column percentage |
+-------------------+

           |     (max) defense
  honorLLM |         0          1 |     Total
-----------+----------------------+----------
         1 |        25         36 |        61 
           |    100.00     100.00 |    100.00 
-----------+----------------------+----------
     Total |        25         36 |        61 
           |    100.00     100.00 |    100.00 


. tab honorLLM defense if dnaLLM~=1 & sample==0, column // 6/43=13.95

+-------------------+
| Key               |
|-------------------|
|     frequency     |
| column percentage |
+-------------------+

           |     (max) defense
  honorLLM |         0          1 |     Total
-----------+----------------------+----------
         1 |         6          6 |        12 
           |    100.00     100.00 |    100.00 
-----------+----------------------+----------
     Total |         6          6 |        12 
           |    100.00     100.00 |    100.00 


. 
. 
. 
. 
. 
. 
. 
. 
end of do-file

. log close
      name:  <unnamed>
       log:  /Users/mattfuhrmann/Dropbox/Alliances(BerkemeierFuhrmann2016)/RAP R
> eview/For submission/Log File.log
  log type:  text
 closed on:   6 Mar 2018, 22:12:04
--------------------------------------------------------------------------------
